package com.ny.demo603;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class UserDao {
    private static final DbUntil dbUntil = new DbUntil();
    Connection conn = dbUntil.getConnection();
    public UserDao() throws SQLException ,ClassNotFoundException{
    }
    public User findUser(String username,String password) throws SQLException, SQLException {
        String sql = "select * from user where username = ? and password = ?";
        PreparedStatement preparedStatement = conn.prepareStatement(sql);
         preparedStatement.setString(1,username);
          preparedStatement.setString(2,password);
           ResultSet resultSet = preparedStatement.executeQuery();
           User user=new User() ;
           if ( resultSet.next()){
               int id= resultSet.getInt("id");
               String name = resultSet.getString("name");
                String pwd = resultSet.getString("password");
                user= new User(id,name,password);
                user.setId( id);
                user.setName(name);
                user.setPassword(pwd);
           }
            return user;
    }
}
